﻿create procedure dbo.GetPaymentSettings
(
		@TakeoutProviderID int
	
	)

AS
	
	SELECT     dbo.PaymentSource.Name AS PaymentSourceName, dbo.PaymentSource.AssemblyInfo, dbo.PaymentSettings.Name AS SettingsName, 
	                      dbo.PaymentSettings.Value AS SettingsValue
	FROM         dbo.TakeoutProvider INNER JOIN
	                      dbo.PaymentSettings ON dbo.TakeoutProvider.Id = dbo.PaymentSettings.TakeoutProviderID INNER JOIN
	                      dbo.PaymentSource ON dbo.TakeoutProvider.PaymentSourceID = dbo.PaymentSource.Id
	WHERE     (dbo.TakeoutProvider.Id = @TakeoutProviderID)


